﻿CREATE TABLE [dbo].[Employee] (
    [Id]          INT             IDENTITY (1, 1) NOT NULL,
    [LegalName]   NVARCHAR (128)  NOT NULL,
    [DateOfBirth] DATE            NOT NULL,
    [Salary]      DECIMAL (18, 2) NOT NULL,
    [Status]      TINYINT         NOT NULL,
    [FirstName]   NVARCHAR (128)  NULL,
    [LastName]    NVARCHAR (128)  NULL,
    CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED ([Id] ASC)
);



